package com.yuyou.fn.educational.mapper;

import com.github.wens.mybatisplus.mapper.AutoMapper;
import com.yuyou.fn.educational.entity.AttendClassRecord;
import org.apache.ibatis.annotations.ResultType;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 *
 * AttendClassRecord 表数据库控制层接口
 *
 */
public interface AttendClassRecordMapper extends AutoMapper<AttendClassRecord,Long> {


    @Select("select acr.attend_class_record_id as attendClassRecordId , acr.class_lecture_id classLectureId , acr.student_id studentId , acr.class_id classId , acr.reg_id regId from `attend_class_record` acr left join student_reg sr on acr.reg_id = sr.reg_id  where shift_Status = 0 and is_Attendance = 1 and  finance_Flag = 0 and sr.`charging_status` <> 0 ")
    @ResultType(AttendClassRecord.class)
    List<AttendClassRecord> queryAttendClassRecordForConsume();


}